<?php
include "../conn.php";
include "t-cookie.php";
?>
<!DOCTYPE html>
<html lang="zh">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>答辩汇总-管理员端</title>
    <link rel="stylesheet" type="text/css" href="../css/htmleaf-demo.css">
    <link rel="stylesheet" type="text/css" href="../css/nav.css">
    <link rel="stylesheet" type="text/css" href="../fonts/iconfont.css">

    <link rel="stylesheet" href="../css/bootstrap-theme.css"/>

    <script type="text/javascript" src="../js/jquery.min.js"></script>
    <link rel="stylesheet" href="../css/bootstrap-theme.min.css"/>
    <link rel="stylesheet" href="../css/bootstrap.css"/>
    <script type="text/javascript" src="../js/bootstrap3.0.3.min.js"></script>

    <link rel="stylesheet" type="text/css" href="../css/style.css">

    <style>
        .panelbt {
            height: 50px;
            padding-top: 15px;
            background-color: #8FBC8F
        }
        .cp h1{
            color:#939292;
            padding:10px;
            font-family: 宋体;
            font-size: 25px;
        }
    </style>

</head>

<body class="bodycolor">

<nav class="navbar navbar-default navbar-fixed-top" style="clear: left;">
    <div class="container">
        <div class="navbar-right navfont" id="navbar-collapse">
            <p>华软网络技术系毕业管理系统</p>
        </div>
        <a href="t-cookie.php?cookie=out" id="out">退出</a>
    </div>

</nav>

<div class="nav topx navbackground-t" id="nav">
    <div>

        <div style="border-bottom:1px solid rgba(255,255,255,.1)"><img src="../images/mini.png"></div>
    </div>
    <ul>
        <li class="nav-item">
            <a href="t-index.php"><i class="my-icon nav-icon icon_2"></i><span>首页</span><i class="my-icon nav-more"></i></a>

        </li>
        <li class="nav-item">
            <a href="t-mykt.php"><i class="my-icon nav-icon icon_1"></i><span>我的课题</span><i
                    class="my-icon nav-more"></i></a>
        </li>
        <li class="nav-item">
            <a href="t-checkproject.php"><i class="my-icon nav-icon icon_6"></i><span>选课核查</span><i
                    class="my-icon nav-more"></i></a>
        </li>
        <li class="nav-item">
            <a href="#"><i class="my-icon nav-icon icon_3"></i><span>评分评语</span><i class="my-icon nav-more"></i></a>
            <ul>
                <li>
                    <a href="t-GuideMark.php"><span>指导评分</span></a>
                </li>
                <li>
                    <a href="t-ThesisMark.php"><span>论文评分</span></a>
                </li>
                <li>
                    <a href="t-ReplyMark.php"><span>答辩评分</span></a>
                </li>
            </ul>
        </li>
        <li class="nav-item">
            <a href="t-all.php"><i class="my-icon nav-icon icon_6"></i><span>答辩汇总</span><i
                    class="my-icon nav-more"></i></a>

        </li>
        <li class="nav-item">
            <a href="#"><i class="my-icon nav-icon icon_3"></i><span>资料管理</span><i class="my-icon nav-more"></i></a>
            <ul>
                <li>
                    <a href="t-information.php"><span>我的资料</span></a>
                </li>
                <li>
                    <a href="t-mystudent.php"><span>我的学生</span></a>
                </li>

            </ul>
        </li>
    </ul>
</div>

<div class="indexborder">

    <div class="bannerdiv">
        <!--colspan="2"-->

        <div class="box-inline indexdiv1 panel panel-default auto cp" align="center">
            <div class="panel panel-default">
                <div class="panelbt">
                    <h3 class="panel-title">论文评分</h3>
                </div>
                <h1>学生选课查看</h1>
                <table class="table table-striped table-condensed ">
                    <thead>
                    <tr>
                        <th>课题名</th>
                        <th>学号</th>
                        <th>学生名</th>
                        <th>性别</th>
                        <th>方向</th>
                        <th>E-mail</th>
                        <th>QQ</th>
                        <th>Tel</th>
                        <th>操作</th>
                    </tr>
                    </thead>
                    <?
                    $TeachId = $_SESSION['t-id'];
                    $sql = "select p.ProjectName,s.StudentId,s.StudentName,s.Sex,s.Major,s.email,s.QQ,s.Tel,p.ProjectId from project as p
JOIN choosesubject as ch on p.ProjectId=ch.ProjectId
JOIN student as s on s.StudentId=ch.StudentId
where p.Teacher_TeacherId=$TeachId and p.activate=0";
                    $result = $conn->query($sql);
                    while ($row = $result->fetch_array()) {
                        ?>
                        <tr>
                            <td data-label="课题名"><?= $row[0] ?></td>
                            <td data-label="学号"><?= $row[1] ?></td>
                            <td data-label="学生名"><?= $row[2] ?></td>
                            <td data-label="性别"><?= $row[3] ?></td>
                            <td data-label="方向"><?= $row[4] ?></td>
                            <td data-label="E-mail"><?= $row[5] ?></td>
                            <td data-label="QQ"><?= $row[6] ?></td>
                            <td data-label="Tel"><?= $row[7] ?></td>
                            <td data-label="操作"><input type="button" value="查看"
                                       onclick="checkstudent('choose',<?= $row[8] ?>,<?= $row[1] ?>)"></td>
                        </tr>

                    <? } ?>
                </table>

                <h1>学生自拟查看</h1>
                <table class="table table-striped table-condensed ">
                    <thead>
                    <tr>
                        <th>课题名</th>
                        <th>类别</th>
                        <th>来源</th>
                        <th>概述</th>
                        <th>学号</th>
                        <th>姓名</th>
                        <th>性别</th>
                        <th>方向</th>
                        <th>E-mail</th>
                        <th>QQ</th>
                        <th>Tel</th>
                        <th>操作</th>
                    </tr>
                    </thead>
                    <?
                    $Year = $_SESSION['t-Year'];
                    $sql = "select ProjectName,Category,ProjectOrigin,Summary,s.StudentId,StudentName,Sex,Major,email,QQ,Tel,ProjectId from probyself as p
JOIN student as s on p.StudentId=s.StudentId
where p.Year=$Year and p.activite=0";
                    $result = $conn->query($sql);
                    while ($row = $result->fetch_array()) {
                        ?>
                        <tr>
                            <td data-label="课题名"><?= $row[0] ?></td>
                            <td data-label="类别"><?= $row[1] ?></td>
                            <td data-label="来源"><?= $row[2] ?></td>
                            <td data-label="概述"><?= $row[3] ?></td>
                            <td data-label="学号"><?= $row[4] ?></td>
                            <td data-label="姓名"><?= $row[5] ?></td>
                            <td data-label="性别"><?= $row[6] ?></td>
                            <td data-label="方向"><?= $row[7] ?></td>
                            <td data-label="E-mail"><?= $row[8] ?></td>
                            <td data-label="QQ"><?= $row[9] ?></td>
                            <td data-label="Tel"><?= $row[10] ?></td>
                            <td data-label="操作"><input type="button" value="查看"
                                       onclick="checkstudent('catch',<?= $row[11] ?>,<?= $row[4] ?>)"></td>
                        </tr>
                    <? } ?>
                </table>

                <script type="text/javascript" src="../js/jquery-1.11.0.min.js"></script>
                <script type="text/javascript">  //弹窗实现
                    function checkstudent(method, projectid, studentid) {
                        var path = "t-taskinfo.php?method=" + method + "&projectid=" + projectid + "&studentid=" + studentid;
//                alert(path);

                        layer.open({
                            type: 1,
                            area: ['80%', '80%'],
                            shadeClose: true, //点击遮罩关闭
                            content: "<iframe src='detailednews.php'  width='98%' height='94%' name=main frameborder= scrolling=NO id='testFrame'></iframe>"
                        });
                        var t = document.getElementById("testFrame");
                        t.src = path;


                    }
                </script>
                <script type="text/javascript" src="../js/nav.js"></script>
                <script type="text/javascript" src="../layer/layer.js"></script>

            </div>
        </div>
    </div>
</div>


<script>
    window.jQuery || document.write('<script src="../js/jquery-1.11.0.min.js"><\/script>')
</script>
<script type="text/javascript" src="../js/nav.js"></script>

</body>

</html>








